explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CUdL

Settings
# exclusive inclusive rows x rows loops node
1. 5.520 227.081 ↑ 3.4 4,752 1

Nested Loop (cost=1,001.00..56,340.26 rows=16,042 width=60) (actual time=2.169..227.081 rows=4,752 loops=1)

2. 0.018 0.018 ↑ 1.0 1 1

Index Scan using doc_type_pkey on s_doc_type dt (cost=0.15..2.37 rows=1 width=36) (actual time=0.014..0.018 rows=1 loops=1)

  • Index Cond: (id = 3)
3. 103.038 221.543 ↑ 3.4 4,752 1

Gather (cost=1,000.85..56,177.47 rows=16,042 width=32) (actual time=2.150..221.543 rows=4,752 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
4. 25.335 118.505 ↑ 4.0 2,376 2 / 2

Nested Loop (cost=0.85..53,573.27 rows=9,436 width=32) (actual time=2.202..118.505 rows=2,376 loops=2)

5. 26.658 26.658 ↑ 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=32) (actual time=2.091..26.658 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
6. 18.139 66.511 ↓ 0.0 0 12,093 / 2

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

7. 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)
8. 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)
9. 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)
10. 48.372 48.372 ↓ 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.008..0.008 rows=0 loops=12,093)

  • Index Cond: (document_id = cd.document_id)
  • Filter: (sale_type_id = 3)
  • Rows Removed by Filter: 1
11. 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)
12. 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)
13. 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)
14. 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)
15. 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 : 2.145 ms
Execution time : 228.121 ms