explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7lGX

Settings
# exclusive inclusive rows x rows loops node
1. 155.128 829.032 ↑ 42,804.5 4 1

Merge Join (cost=93,261.97..171,540.16 rows=171,218 width=4) (actual time=828.704..829.032 rows=4 loops=1)

  • Merge Cond: (respart.sno = mylajob.rpsno)
2. 459.253 459.253 ↑ 1.0 2,835,986 1

Index Only Scan using tres_death_sno on respart (cost=0.43..116,138.18 rows=2,871,791 width=4) (actual time=0.037..459.253 rows=2,835,986 loops=1)

  • Index Cond: ((restype = 0) AND (death = 'infinity'::abstime))
  • Heap Fetches: 578087
3. 0.020 214.651 ↑ 1,210.7 117 1

Materialize (cost=45,722.90..46,431.16 rows=141,652 width=8) (actual time=214.619..214.651 rows=117 loops=1)

4. 0.061 214.631 ↑ 1,210.7 117 1

Sort (cost=45,722.90..46,077.03 rows=141,652 width=8) (actual time=214.616..214.631 rows=117 loops=1)

  • Sort Key: mylajob.rpsno
  • Sort Method: quicksort Memory: 30kB
5. 214.570 214.570 ↑ 1,210.7 117 1

Index Scan using myjob_pt_idx on mylajob (cost=0.42..31,664.16 rows=141,652 width=8) (actual time=0.037..214.570 rows=117 loops=1)

  • Index Cond: (pt IS NULL)
  • Filter: (death = 'infinity'::abstime)
  • Rows Removed by Filter: 310956