explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xIqS

Settings
# exclusive inclusive rows x rows loops node
1. 2,045.399 19,577.314 ↑ 32.6 49 1

HashAggregate (cost=1,067,943.71..1,067,959.67 rows=1,596 width=101) (actual time=19,577.296..19,577.314 rows=49 loops=1)

  • Group Key: dl.name, dl.id
2. 216.942 17,531.915 ↓ 1.0 256,045 1

Hash Left Join (cost=446,488.74..1,021,885.09 rows=252,376 width=101) (actual time=12,717.093..17,531.915 rows=256,045 loops=1)

  • Hash Cond: (flap.app_started__location_id = dl.id)
3. 1,926.157 17,312.789 ↓ 1.0 256,045 1

Hash Right Join (cost=446,393.83..1,018,184.48 rows=252,376 width=79) (actual time=12,714.878..17,312.789 rows=256,045 loops=1)

  • Hash Cond: ((la.id)::text = (flap.loan_application_id)::text)
4. 2,678.808 2,678.808 ↑ 1.0 1,196,496 1

Seq Scan on loan_application la (cost=0.00..527,408.17 rows=1,199,017 width=49) (actual time=0.015..2,678.808 rows=1,196,496 loops=1)

5. 872.705 12,707.824 ↓ 1.0 256,045 1

Hash (cost=439,788.13..439,788.13 rows=252,376 width=81) (actual time=12,707.824..12,707.824 rows=256,045 loops=1)

  • Buckets: 4096 Batches: 8 Memory Usage: 3174kB
6. 2,080.860 11,835.119 ↓ 1.0 256,045 1

Bitmap Heap Scan on fact_loan_application_pipeline flap (cost=35,988.34..439,788.13 rows=252,376 width=81) (actual time=9,764.344..11,835.119 rows=256,045 loops=1)

  • Recheck Cond: (app_started__tenant_id = 131)
  • Rows Removed by Index Recheck: 388496
  • Heap Blocks: exact=47501 lossy=107040
7. 9,754.259 9,754.259 ↓ 1.0 256,715 1

Bitmap Index Scan on idx_fact_loan_application_pipeline_app_started__tenant_id (cost=0.00..35,925.25 rows=252,376 width=0) (actual time=9,754.259..9,754.259 rows=256,715 loops=1)

  • Index Cond: (app_started__tenant_id = 131)
8. 0.920 2.184 ↑ 1.0 1,596 1

Hash (cost=74.96..74.96 rows=1,596 width=30) (actual time=2.184..2.184 rows=1,596 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 104kB
9. 1.264 1.264 ↑ 1.0 1,596 1

Seq Scan on dim_location dl (cost=0.00..74.96 rows=1,596 width=30) (actual time=0.009..1.264 rows=1,596 loops=1)

Planning time : 4.137 ms
Execution time : 19,578.386 ms