explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CG7N

Settings
# exclusive inclusive rows x rows loops node
1. 108.552 226.375 ↑ 3.4 4,752 1

Gather (cost=1,000.85..56,177.47 rows=16,042 width=36) (actual time=2.003..226.375 rows=4,752 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
2. 21.531 117.823 ↑ 4.0 2,376 2 / 2

Nested Loop (cost=0.85..53,573.27 rows=9,436 width=36) (actual time=0.129..117.823 rows=2,376 loops=2)

3. 23.734 23.734 ↑ 1.2 6,046 2 / 2

Parallel Index Scan using c_document_2020summer_issue_date_idx on c_document_2020summer cd (cost=0.42..1,392.83 rows=7,150 width=36) (actual time=0.050..23.734 rows=6,046 loops=2)

  • Index Cond: ((issue_date >= '2020-06-05 00:00:00'::timestamp without time zone) AND (issue_date <= '2020-06-20 00:00:00'::timestamp without time zone))
  • Filter: (doc_type_id = 3)
  • Rows Removed by Filter: 18,068
4. 12.093 72.558 ↓ 0.0 0 12,093 / 2

Append (cost=0.42..7.21 rows=9 width=8) (actual time=0.012..0.012 rows=0 loops=12,093)

5. 0.000 0.000 ↓ 0.0 0 / 2

Index Scan using c_sale_500k_document_id_idx on c_sale_500k s (cost=0.42..0.93 rows=1 width=8) (never executed)

  • Index Cond: (document_id = cd.document_id)
  • Filter: (sale_type_id = 3)
6. 0.000 0.000 ↓ 0.0 0 / 2

Index Scan using c_sale_1000k_document_id_idx on c_sale_1000k s_1 (cost=0.42..0.93 rows=1 width=8) (never executed)

  • Index Cond: (document_id = cd.document_id)
  • Filter: (sale_type_id = 3)
7. 0.000 0.000 ↓ 0.0 0 / 2

Index Scan using c_sale_1500k_document_id_idx on c_sale_1500k s_2 (cost=0.42..0.93 rows=1 width=8) (never executed)

  • Index Cond: (document_id = cd.document_id)
  • Filter: (sale_type_id = 3)
8. 60.465 60.465 ↓ 0.0 0 12,093 / 2

Index Scan using c_sale_2000k_document_id_idx on c_sale_2000k s_3 (cost=0.42..0.93 rows=1 width=8) (actual time=0.010..0.010 rows=0 loops=12,093)

  • Index Cond: (document_id = cd.document_id)
  • Filter: (sale_type_id = 3)
  • Rows Removed by Filter: 1
9. 0.000 0.000 ↓ 0.0 0 / 2

Index Scan using c_sale_2500k_document_id_idx on c_sale_2500k s_4 (cost=0.42..0.93 rows=1 width=8) (never executed)

  • Index Cond: (document_id = cd.document_id)
  • Filter: (sale_type_id = 3)
10. 0.000 0.000 ↓ 0.0 0 / 2

Index Scan using c_sale_3000k_document_id_idx on c_sale_3000k s_5 (cost=0.42..0.93 rows=1 width=8) (never executed)

  • Index Cond: (document_id = cd.document_id)
  • Filter: (sale_type_id = 3)
11. 0.000 0.000 ↓ 0.0 0 / 2

Index Scan using c_sale_3500k_document_id_idx on c_sale_3500k s_6 (cost=0.42..0.93 rows=1 width=8) (never executed)

  • Index Cond: (document_id = cd.document_id)
  • Filter: (sale_type_id = 3)
12. 0.000 0.000 ↓ 0.0 0 / 2

Index Scan using c_sale_4000k_document_id_idx on c_sale_4000k s_7 (cost=0.29..0.32 rows=1 width=8) (never executed)

  • Index Cond: (document_id = cd.document_id)
  • Filter: (sale_type_id = 3)
13. 0.000 0.000 ↓ 0.0 0 / 2

Index Scan using c_sale_4500k_document_id_idx on c_sale_4500k s_8 (cost=0.15..0.31 rows=1 width=8) (never executed)

  • Index Cond: (document_id = cd.document_id)
  • Filter: (sale_type_id = 3)
Planning time : 1.660 ms
Execution time : 227.045 ms