explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pAjo

Settings
# exclusive inclusive rows x rows loops node
1. 0.033 334.762 ↓ 0.0 0 1

Nested Loop (cost=105.58..16,217.87 rows=1 width=38) (actual time=334.762..334.762 rows=0 loops=1)

  • Join Filter: ((n.dob)::date = p.dob)
  • Rows Removed by Join Filter: 10
2. 0.034 334.659 ↓ 10.0 10 1

Nested Loop (cost=105.15..16,217.33 rows=1 width=29) (actual time=18.627..334.659 rows=10 loops=1)

3. 0.073 334.525 ↓ 10.0 10 1

Nested Loop (cost=104.72..16,216.28 rows=1 width=29) (actual time=18.614..334.525 rows=10 loops=1)

4. 52.622 80.012 ↓ 10.0 10 1

Hash Join (cost=104.72..10,984.11 rows=1 width=14) (actual time=6.390..80.012 rows=10 loops=1)

  • Hash Cond: (pt_cn.casesid = c.casesid)
5. 26.812 26.812 ↑ 1.0 433,191 1

Seq Scan on pt_casesnames pt_cn (cost=0.00..9,254.91 rows=433,191 width=16) (actual time=0.003..26.812 rows=433,191 loops=1)

6. 0.002 0.578 ↑ 1.0 2 1

Hash (cost=104.70..104.70 rows=2 width=14) (actual time=0.578..0.578 rows=2 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
7. 0.002 0.576 ↑ 1.0 2 1

Nested Loop (cost=0.43..104.70 rows=2 width=14) (actual time=0.169..0.576 rows=2 loops=1)

8. 0.558 0.558 ↑ 1.0 2 1

Seq Scan on armms_jp_expunge e (cost=0.00..87.79 rows=2 width=15) (actual time=0.157..0.558 rows=2 loops=1)

  • Filter: (nameid = '258488'::numeric)
  • Rows Removed by Filter: 3421
9. 0.016 0.016 ↑ 1.0 1 2

Index Scan using cases_casename_key on cases c (cost=0.43..8.45 rows=1 width=18) (actual time=0.008..0.008 rows=1 loops=2)

  • Index Cond: ((casename)::text = (e.item_number)::text)
10. 254.440 254.440 ↑ 1.0 1 10

Seq Scan on armms_jp_names n (cost=0.00..5,232.16 rows=1 width=27) (actual time=12.187..25.444 rows=1 loops=10)

  • Filter: (nameid = '258488'::numeric)
  • Rows Removed by Filter: 150012
11. 0.100 0.100 ↑ 1.0 1 10

Index Scan using names_pkey on names n2 (cost=0.43..1.04 rows=1 width=16) (actual time=0.010..0.010 rows=1 loops=10)

  • Index Cond: (namesid = pt_cn.namesid)
12. 0.070 0.070 ↑ 1.0 1 10

Index Scan using people_pkey on people p (cost=0.43..0.52 rows=1 width=25) (actual time=0.006..0.007 rows=1 loops=10)

  • Index Cond: (peopleid = n2.peopleid)
Planning time : 1.022 ms
Execution time : 334.886 ms