explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WAmQ

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 404.489 ↓ 0.0 0 1

Limit (cost=79.03..167.67 rows=10 width=100) (actual time=404.489..404.489 rows=0 loops=1)

2. 0.000 404.488 ↓ 0.0 0 1

Nested Loop (cost=79.03..242,662.17 rows=27,367 width=100) (actual time=404.488..404.488 rows=0 loops=1)

3. 0.001 404.488 ↓ 0.0 0 1

Nested Loop (cost=78.60..229,238.48 rows=27,367 width=104) (actual time=404.488..404.488 rows=0 loops=1)

4. 0.000 404.487 ↓ 0.0 0 1

Nested Loop (cost=78.18..210,440.45 rows=27,367 width=100) (actual time=404.487..404.487 rows=0 loops=1)

5. 0.000 404.487 ↓ 0.0 0 1

Nested Loop (cost=77.75..195,401.52 rows=27,371 width=100) (actual time=404.487..404.487 rows=0 loops=1)

6. 0.002 404.487 ↓ 0.0 0 1

Hash Semi Join (cost=77.20..50,601.12 rows=68,980 width=96) (actual time=404.487..404.487 rows=0 loops=1)

  • Hash Cond: ((bil.institution_code)::text = (institution.institution_code)::text)
7. 404.485 404.485 ↓ 0.0 0 1

Seq Scan on thist_dataupload_billing bil (cost=0.00..49,575.44 rows=68,980 width=101) (actual time=404.485..404.485 rows=0 loops=1)

  • Filter: ((NOT is_dump) AND ((biller_code)::text = '34567'::text) AND ((version_note)::text = 'BILLKEY.34567.0.1'::text) AND (bill_status = 'VALID'::status_bill))
  • Rows Removed by Filter: 787148
8. 0.000 0.000 ↓ 0.0 0

Hash (cost=74.94..74.94 rows=181 width=118) (never executed)

9. 0.000 0.000 ↓ 0.0 0

Unique (cost=72.23..73.13 rows=181 width=118) (never executed)

10.          

CTE institution

11. 0.000 0.000 ↓ 0.0 0

Recursive Union (cost=0.00..61.82 rows=181 width=6) (never executed)

12. 0.000 0.000 ↓ 0.0 0

Seq Scan on mdata_cst_institution (cost=0.00..4.76 rows=1 width=6) (never executed)

  • Filter: ((institution_code)::text = 'HALO000'::text)
13. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=0.33..5.34 rows=18 width=6) (never executed)

  • Hash Cond: ((chd.ref_id)::text = (prt.institution_code)::text)
14. 0.000 0.000 ↓ 0.0 0

Seq Scan on mdata_cst_institution chd (cost=0.00..4.61 rows=61 width=13) (never executed)

15. 0.000 0.000 ↓ 0.0 0

Hash (cost=0.20..0.20 rows=10 width=118) (never executed)

16. 0.000 0.000 ↓ 0.0 0

WorkTable Scan on institution prt (cost=0.00..0.20 rows=10 width=118) (never executed)

17. 0.000 0.000 ↓ 0.0 0

Sort (cost=10.41..10.86 rows=181 width=118) (never executed)

  • Sort Key: institution.institution_code
18. 0.000 0.000 ↓ 0.0 0

CTE Scan on institution (cost=0.00..3.62 rows=181 width=118) (never executed)

19. 0.000 0.000 ↓ 0.0 0

Index Scan using thist_dataupload_billing_billinfo_unique on thist_dataupload_billing_billinfo inf (cost=0.55..2.09 rows=1 width=64) (never executed)

  • Index Cond: (((key_full)::text = (bil.key_full)::text) AND ((upload_no)::text = (bil.upload_no)::text))
  • Filter: ((NOT is_dump) AND is_current)
20. 0.000 0.000 ↓ 0.0 0

Index Scan using thist_dataupload_billing_billinfo_pkey on thist_dataupload_billing_billinfo p_002 (cost=0.42..0.54 rows=1 width=4) (never executed)

  • Index Cond: (id = inf.id)
  • Filter: (is_current AND (NOT is_dump))
21. 0.000 0.000 ↓ 0.0 0

Index Only Scan using thist_dataupload_billing_pkey on thist_dataupload_billing (cost=0.42..0.68 rows=1 width=4) (never executed)

  • Index Cond: (id = bil.id)
  • Heap Fetches: 0
22. 0.000 0.000 ↓ 0.0 0

Index Only Scan using thist_dataupload_billing_pkey on thist_dataupload_billing p_003 (cost=0.42..0.46 rows=1 width=4) (never executed)

  • Index Cond: (id = thist_dataupload_billing.id)
  • Heap Fetches: 0
Planning time : 2.310 ms
Execution time : 404.612 ms