explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8mgX

Settings
# exclusive inclusive rows x rows loops node
1. 0.013 0.129 ↑ 40,691.0 1 1

Merge Join (cost=720.17..1,337.33 rows=40,691 width=128) (actual time=0.127..0.129 rows=1 loops=1)

  • Merge Cond: (c.bc_id = b.bc_id)
2. 0.044 0.057 ↑ 680.0 2 1

Sort (cost=94.38..97.78 rows=1,360 width=32) (actual time=0.057..0.057 rows=2 loops=1)

  • Sort Key: c.bc_id
  • Sort Method: quicksort Memory: 25kB
3. 0.013 0.013 ↑ 680.0 2 1

Seq Scan on c (cost=0.00..23.60 rows=1,360 width=32) (actual time=0.012..0.013 rows=2 loops=1)

4. 0.013 0.059 ↑ 2,992.0 2 1

Sort (cost=625.78..640.74 rows=5,984 width=96) (actual time=0.059..0.059 rows=2 loops=1)

  • Sort Key: b.bc_id
  • Sort Method: quicksort Memory: 25kB
5. 0.011 0.046 ↑ 2,992.0 2 1

Merge Join (cost=156.22..250.38 rows=5,984 width=96) (actual time=0.042..0.046 rows=2 loops=1)

  • Merge Cond: (b.ab_id = a.ab_id)
6. 0.012 0.017 ↑ 293.3 3 1

Sort (cost=61.84..64.04 rows=880 width=64) (actual time=0.016..0.017 rows=3 loops=1)

  • Sort Key: b.ab_id
  • Sort Method: quicksort Memory: 25kB
7. 0.005 0.005 ↑ 220.0 4 1

Seq Scan on b (cost=0.00..18.80 rows=880 width=64) (actual time=0.004..0.005 rows=4 loops=1)

8. 0.012 0.018 ↑ 680.0 2 1

Sort (cost=94.38..97.78 rows=1,360 width=32) (actual time=0.017..0.018 rows=2 loops=1)

  • Sort Key: a.ab_id
  • Sort Method: quicksort Memory: 25kB
9. 0.006 0.006 ↑ 680.0 2 1

Seq Scan on a (cost=0.00..23.60 rows=1,360 width=32) (actual time=0.005..0.006 rows=2 loops=1)

Planning time : 0.513 ms
Execution time : 0.232 ms