explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7fSW

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 4,723.812 ↓ 0.0 0 1

Gather Merge (cost=6,374,669.61..6,376,934.96 rows=19,416 width=68) (actual time=4,722.223..4,723.812 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 1
2. 0.038 9,433.936 ↓ 0.0 0 2

Sort (cost=6,373,669.58..6,373,693.85 rows=9,708 width=68) (actual time=4,716.968..4,716.968 rows=0 loops=2)

  • Sort Key: cdmversion0_.version_id, cdmversion0_.sort_order
  • Sort Method: quicksort Memory: 25kB
  • Worker 0: Sort Method: quicksort Memory: 25kB
3. 0.000 9,433.898 ↓ 0.0 0 2

Nested Loop (cost=1.27..6,373,026.67 rows=9,708 width=68) (actual time=4,716.949..4,716.949 rows=0 loops=2)

4. 0.002 9,433.898 ↓ 0.0 0 2

Nested Loop (cost=0.70..6,289,548.68 rows=9,732 width=52) (actual time=4,716.949..4,716.949 rows=0 loops=2)

5. 9,433.896 9,433.896 ↓ 0.0 0 2

Parallel Seq Scan on cdm_version_cust_data cdmversion1_ (cost=0.00..1,020,500.57 rows=346 width=23) (actual time=4,716.948..4,716.948 rows=0 loops=2)

  • Filter: ((id > 0) AND (id <= 5000) AND ((status)::text = 'A'::text) AND (dataset_id = 1002))
  • Rows Removed by Filter: 19947334
6. 0.000 0.000 ↓ 0.0 0

Index Scan using cdm_cust_data_detail_pkey on cdm_cust_data_detail cdmversion0_ (cost=0.70..15,130.50 rows=9,796 width=37) (never executed)

  • Index Cond: (version_id = cdmversion1_.id)
7. 0.000 0.000 ↓ 0.0 0

Index Scan using cdm_master_cust_data_pkey on cdm_master_cust_data cdmmasterc2_ (cost=0.56..8.58 rows=1 width=24) (never executed)

  • Index Cond: (id = cdmversion1_.master_id)
Planning time : 0.619 ms