explain.depesz.com

PostgreSQL's explain analyze made readable

Result: euod

Settings
# exclusive inclusive rows x rows loops node
1. 0.014 4.600 ↑ 1.0 100 1

Limit (cost=4.23..53.11 rows=100 width=841) (actual time=1.037..4.600 rows=100 loops=1)

2. 0.079 4.586 ↑ 293.7 100 1

Nested Loop (cost=4.23..14,359.22 rows=29,371 width=841) (actual time=1.036..4.586 rows=100 loops=1)

3. 0.012 0.784 ↑ 340.4 17 1

Nested Loop (cost=3.80..4,464.14 rows=5,787 width=750) (actual time=0.732..0.784 rows=17 loops=1)

4. 0.001 0.059 ↑ 10.0 1 1

Limit (cost=0.00..959.42 rows=10 width=145) (actual time=0.059..0.059 rows=1 loops=1)

5. 0.020 0.058 ↑ 203.0 1 1

Nested Loop (cost=0.00..19,476.21 rows=203 width=145) (actual time=0.058..0.058 rows=1 loops=1)

6. 0.024 0.024 ↑ 203.0 1 1

Sample Scan on ld203 l (cost=0.00..19,464.54 rows=203 width=81) (actual time=0.024..0.024 rows=1 loops=1)

  • Sampling: bernoulli ('0.06666667'::real)
  • Filter: (filer_type = 'L'::bpchar)
7. 0.014 0.014 ↑ 1.0 1 1

Function Scan on array_to_string lc_full_name (cost=0.00..0.01 rows=1 width=32) (actual time=0.014..0.014 rows=1 loops=1)

8. 0.265 0.713 ↑ 10.4 17 1

Bitmap Heap Scan on reports___fxml r (cost=3.80..348.69 rows=177 width=605) (actual time=0.669..0.713 rows=17 loops=1)

  • Recheck Cond: (("left"(house_id, 5))::integer = l.house_reg_id)
  • Heap Blocks: exact=12
9. 0.448 0.448 ↓ 14.2 2,520 1

Bitmap Index Scan on reports___fxml_left_idx (cost=0.00..3.75 rows=177 width=0) (actual time=0.448..0.448 rows=2,520 loops=1)

  • Index Cond: (("left"(house_id, 5))::integer = l.house_reg_id)
10. 3.723 3.723 ↑ 6.5 6 17

Index Scan using lobbyists___fxml_pkey on lobbyists___fxml lf (cost=0.43..1.32 rows=39 width=107) (actual time=0.208..0.219 rows=6 loops=17)

  • Index Cond: (report_uuid = r.report_uuid)
Planning time : 1.204 ms
Execution time : 4.726 ms