explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tMDB : Record Eligibility

Settings
# exclusive inclusive rows x rows loops node
1. 1,024.153 31,982.241 ↑ 1.2 6 1

GroupAggregate (cost=340,115.50..362,475.17 rows=7 width=210) (actual time=31,706.610..31,982.241 rows=6 loops=1)

  • Group Key: list.list_id
  • Functions: 165
  • Options: Inlining false, Optimization false, Expressions true, Deforming true
  • Timing: Generation 69.306 ms, Inlining 0.000 ms, Optimization 12.118 ms, Emission 596.949 ms, Total 678.373 ms
2. 706.726 30,958.088 ↓ 4.5 855,179 1

Sort (cost=340,115.50..340,591.23 rows=190,293 width=92) (actual time=30,798.488..30,958.088 rows=855,179 loops=1)

  • Sort Key: list.list_id
  • Sort Method: external merge Disk: 94,120kB
3. 559.845 30,251.362 ↓ 4.5 855,179 1

Gather (cost=24,603.40..323,428.83 rows=190,293 width=92) (actual time=2,344.748..30,251.362 rows=855,179 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
4. 110.254 29,691.517 ↓ 3.6 171,036 5 / 5

Nested Loop (cost=23,603.40..303,399.53 rows=47,573 width=92) (actual time=2,243.662..29,691.517 rows=171,036 loops=5)

5. 64.829 23,281.557 ↓ 5.0 149,993 5 / 5

Hash Left Join (cost=23,602.96..216,649.32 rows=30,114 width=67) (actual time=2,243.603..23,281.557 rows=149,993 loops=5)

  • Hash Cond: (lead.lead_id = callback.lead_id)
6. 129.548 23,216.622 ↓ 5.0 149,993 5 / 5

Hash Join (cost=23,591.46..216,524.87 rows=30,114 width=63) (actual time=2,243.442..23,216.622 rows=149,993 loops=5)

  • Hash Cond: (lead.list_id = list.list_id)
7. 22,558.129 22,964.695 ↑ 2.1 164,495 5 / 5

Parallel Bitmap Heap Scan on lead (cost=23,580.27..215,453.78 rows=352,759 width=41) (actual time=2,120.931..22,964.695 rows=164,495 loops=5)

  • Recheck Cond: ((import_date >= '2020-10-01 00:00:00+01'::timestamp with time zone) AND (import_date < '2020-11-01 00:00:00+00'::timestamp with time zone))
  • Filter: (final_code_id <> 100)
  • Rows Removed by Filter: 190,800
  • Heap Blocks: exact=16,187
8. 406.566 406.566 ↓ 1.0 1,821,336 1 / 5

Bitmap Index Scan on idx_lead_importdate (cost=0.00..23,227.51 rows=1,770,508 width=0) (actual time=2,032.832..2,032.832 rows=1,821,336 loops=1)

  • Index Cond: ((import_date >= '2020-10-01 00:00:00+01'::timestamp with time zone) AND (import_date < '2020-11-01 00:00:00+00'::timestamp with time zone))
9. 0.019 122.379 ↑ 1.0 7 5 / 5

Hash (cost=10.96..10.96 rows=7 width=26) (actual time=122.378..122.379 rows=7 loops=5)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
10. 122.360 122.360 ↑ 1.0 7 5 / 5

Index Scan using pk_list on list (cost=0.14..10.96 rows=7 width=26) (actual time=122.330..122.360 rows=7 loops=5)

  • Index Cond: (list_id = ANY ('{51,81,87,107,84,104,106}'::integer[]))
11. 0.004 0.106 ↑ 10.0 4 5 / 5

Hash (cost=10.20..10.20 rows=40 width=12) (actual time=0.106..0.106 rows=4 loops=5)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
12. 0.102 0.102 ↑ 10.0 4 5 / 5

Seq Scan on callback (cost=0.00..10.20 rows=40 width=12) (actual time=0.101..0.102 rows=4 loops=5)

13. 6,299.706 6,299.706 ↑ 3.0 1 749,965 / 5

Index Scan using idx_lead_phone_leadid on lead_phone (cost=0.43..2.79 rows=3 width=33) (actual time=0.032..0.042 rows=1 loops=749,965)

  • Index Cond: (lead_id = lead.lead_id)
  • Filter: (final_code_id <> 100)
Planning time : 3.354 ms
Execution time : 32,191.592 ms