explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xYhM

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 184.173 ↑ 16.0 1 1

Nested Loop (cost=304,776.16..304,776.74 rows=16 width=16) (actual time=184.172..184.173 rows=1 loops=1)

2. 0.000 53.481 ↑ 1.0 1 1

Finalize Aggregate (cost=134,837.08..134,837.09 rows=1 width=8) (actual time=53.481..53.481 rows=1 loops=1)

3. 4.598 53.815 ↓ 1.5 3 1

Gather (cost=134,836.87..134,837.08 rows=2 width=8) (actual time=53.349..53.815 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 3.842 49.217 ↑ 1.0 1 3

Partial Aggregate (cost=133,836.87..133,836.88 rows=1 width=8) (actual time=49.217..49.217 rows=1 loops=3)

5. 30.550 45.375 ↑ 1.0 60,973 3

Parallel Bitmap Heap Scan on t_fait_tex_exploitations_fex (cost=7,127.80..133,678.17 rows=63,480 width=0) (actual time=12.787..45.375 rows=60,973 loops=3)

  • Recheck Cond: (fex_id_date = 20180930)
  • Filter: ((fex_id_lieu_exploitation IS NOT NULL) AND ((fex_nb_bovins_presents_fin_mois)::integer <> 0))
  • Rows Removed by Filter: 40089
  • Heap Blocks: exact=2401
6. 14.825 14.825 ↑ 1.1 303,184 1

Bitmap Index Scan on i_fex_id_date_text (cost=0.00..7,089.71 rows=325,504 width=0) (actual time=14.825..14.825 rows=303,184 loops=1)

  • Index Cond: (fex_id_date = 20180930)
7. 27.645 130.687 ↑ 16.0 1 1

HashAggregate (cost=169,939.07..169,939.23 rows=16 width=12) (actual time=130.687..130.687 rows=1 loops=1)

  • Group Key: ex.fex_id_date
8. 15.730 103.042 ↓ 1.2 178,414 1

Nested Loop (cost=6,785.68..169,213.75 rows=145,065 width=4) (actual time=14.373..103.042 rows=178,414 loops=1)

9. 0.004 0.021 ↑ 1.0 1 1

Result (cost=0.48..0.49 rows=1 width=4) (actual time=0.020..0.021 rows=1 loops=1)

10.          

Initplan (forResult)

11. 0.001 0.017 ↑ 1.0 1 1

Limit (cost=0.43..0.48 rows=1 width=4) (actual time=0.017..0.017 rows=1 loops=1)

12. 0.016 0.016 ↑ 4,958,940.0 1 1

Index Only Scan Backward using i_fex_id_date_text on t_fait_tex_exploitations_fex t_fait_tex_exploitations_fex_1 (cost=0.43..228,923.13 rows=4,958,940 width=4) (actual time=0.016..0.016 rows=1 loops=1)

  • Index Cond: (fex_id_date IS NOT NULL)
  • Heap Fetches: 0
13. 73.769 87.291 ↓ 1.2 178,414 1

Bitmap Heap Scan on t_fait_tex_exploitations_fex ex (cost=6,785.20..167,762.60 rows=145,065 width=4) (actual time=14.346..87.291 rows=178,414 loops=1)

  • Recheck Cond: (fex_id_date = ($0))
  • Filter: ((fex_id_lieu_exploitation IS NOT NULL) AND ((fex_nb_bovins_presents_fin_mois)::integer <> 0))
  • Rows Removed by Filter: 116401
  • Heap Blocks: exact=5959
14. 13.522 13.522 ↑ 1.1 294,815 1

Bitmap Index Scan on i_fex_id_date_text (cost=0.00..6,748.94 rows=309,934 width=0) (actual time=13.522..13.522 rows=294,815 loops=1)

  • Index Cond: (fex_id_date = ($0))
Planning time : 0.523 ms
Execution time : 184.621 ms