explain.depesz.com

PostgreSQL's explain analyze made readable

Result: f2Nx

Settings
# exclusive inclusive rows x rows loops node
1. 233.980 851.706 ↑ 291.4 4,752 1

Hash Join (cost=1,794.61..83,059.71 rows=1,384,702 width=36) (actual time=540.076..851.706 rows=4,752 loops=1)

  • Hash Cond: (s.document_id = cd.document_id)
2. 146.618 586.932 ↓ 1.0 1,384,750 1

Append (cost=0.42..62,225.87 rows=1,384,702 width=8) (actual time=0.026..586.932 rows=1,384,750 loops=1)

3. 119.543 119.543 ↑ 1.0 196,989 1

Index Scan using c_sale_500k_sale_type_id_idx on c_sale_500k s (cost=0.42..7,867.51 rows=196,999 width=8) (actual time=0.025..119.543 rows=196,989 loops=1)

  • Index Cond: (sale_type_id = 3)
4. 72.263 72.263 ↓ 1.0 196,856 1

Index Scan using c_sale_1000k_sale_type_id_idx on c_sale_1000k s_1 (cost=0.42..7,859.33 rows=196,827 width=8) (actual time=0.025..72.263 rows=196,856 loops=1)

  • Index Cond: (sale_type_id = 3)
5. 60.408 60.408 ↑ 1.0 196,344 1

Index Scan using c_sale_1500k_sale_type_id_idx on c_sale_1500k s_2 (cost=0.42..7,859.27 rows=196,794 width=8) (actual time=0.020..60.408 rows=196,344 loops=1)

  • Index Cond: (sale_type_id = 3)
6. 53.482 53.482 ↓ 1.0 196,878 1

Index Scan using c_sale_2000k_sale_type_id_idx on c_sale_2000k s_3 (cost=0.42..7,854.04 rows=196,229 width=8) (actual time=0.020..53.482 rows=196,878 loops=1)

  • Index Cond: (sale_type_id = 3)
7. 48.485 48.485 ↓ 1.0 197,011 1

Index Scan using c_sale_2500k_sale_type_id_idx on c_sale_2500k s_4 (cost=0.42..7,851.16 rows=196,529 width=8) (actual time=0.016..48.485 rows=197,011 loops=1)

  • Index Cond: (sale_type_id = 3)
8. 44.596 44.596 ↑ 1.0 196,438 1

Index Scan using c_sale_3000k_sale_type_id_idx on c_sale_3000k s_5 (cost=0.42..7,849.51 rows=196,573 width=8) (actual time=0.015..44.596 rows=196,438 loops=1)

  • Index Cond: (sale_type_id = 3)
9. 40.223 40.223 ↑ 1.0 197,550 1

Index Scan using c_sale_3500k_sale_type_id_idx on c_sale_3500k s_6 (cost=0.42..7,885.02 rows=198,059 width=8) (actual time=0.013..40.223 rows=197,550 loops=1)

  • Index Cond: (sale_type_id = 3)
10. 1.309 1.309 ↑ 1.0 6,684 1

Index Scan using c_sale_4000k_sale_type_id_idx on c_sale_4000k s_7 (cost=0.29..268.97 rows=6,684 width=8) (actual time=0.013..1.309 rows=6,684 loops=1)

  • Index Cond: (sale_type_id = 3)
11. 0.002 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on c_sale_4500k s_8 (cost=1.31..7.55 rows=8 width=8) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: (sale_type_id = 3)
12. 0.003 0.003 ↓ 0.0 0 1

Bitmap Index Scan on c_sale_4500k_sale_type_id_idx (cost=0.00..1.31 rows=8 width=0) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (sale_type_id = 3)
13. 4.485 30.794 ↑ 1.0 12,093 1

Hash (cost=1,642.25..1,642.25 rows=12,155 width=36) (actual time=30.794..30.794 rows=12,093 loops=1)

  • Buckets: 16,384 Batches: 1 Memory Usage: 979kB
14. 26.309 26.309 ↑ 1.0 12,093 1

Index Scan using c_document_2020summer_issue_date_idx on c_document_2020summer cd (cost=0.42..1,642.25 rows=12,155 width=36) (actual time=0.027..26.309 rows=12,093 loops=1)

  • 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: 36,135
Planning time : 1.939 ms
Execution time : 852.081 ms