explain.depesz.com

PostgreSQL's explain analyze made readable

Result: a8z

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 512.617 ↑ 1.0 1 1

Finalize Aggregate (cost=336,831.63..336,831.64 rows=1 width=8) (actual time=512.617..512.617 rows=1 loops=1)

2. 90.140 600.865 ↓ 1.5 3 1

Gather (cost=336,831.42..336,831.63 rows=2 width=8) (actual time=512.610..600.865 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 1.233 510.725 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=335,831.42..335,831.43 rows=1 width=8) (actual time=510.725..510.725 rows=1 loops=3)

4. 509.492 509.492 ↓ 1.0 21,333 3 / 3

Parallel Index Scan using crm_lead_create_date_idx on crm_lead (cost=0.43..335,780.58 rows=20,335 width=0) (actual time=1.507..509.492 rows=21,333 loops=3)

  • Index Cond: (create_date >= '2017-06-01 09:37:16'::timestamp without time zone)
  • Filter: (active AND (email_from IS NOT NULL) AND (country_id = ANY ('{1,6,7,9,10,13,16,17,20,21,22,24,25,32,33,34,38,39,40,41,42,45,49,50,52,54,55,56,57,58,61,63,65,67,68,69,73,74,75,77,79,80,82,83,85,86,90,95,97,99,100,105,106,110,111,114,120,124,126,127,128,129,130,132,133,134,135,137,138,146,147,149,152,153,155,157,159,160,163,173,177,181,182,183,184,187,189,191,192,193,194,195,196,197,200,203,205,206,207,209,211,212,215,219,220,221,222,223,226,227,237,239,240,242,26,249,253,254,255,290,315}'::integer[])))
  • Rows Removed by Filter: 522,686
Planning time : 2.484 ms
Execution time : 600.905 ms