explain.depesz.com

PostgreSQL's explain analyze made readable

Result: q5u1

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.012 245,978.231 ↑ 1.0 10 1

Limit (cost=34,508,149.59..34,641,721.37 rows=10 width=16) (actual time=240,209.921..245,978.231 rows=10 loops=1)

2. 1,893.856 245,978.219 ↑ 7.3 10 1

Unique (cost=34,508,149.59..35,483,223.57 rows=73 width=16) (actual time=240,209.920..245,978.219 rows=10 loops=1)

3. 172,475.525 244,084.363 ↑ 9.8 19,861,393 1

Sort (cost=34,508,149.59..34,995,686.58 rows=195,014,795 width=16) (actual time=240,209.918..244,084.363 rows=19,861,393 loops=1)

  • Sort Key: refinitiv_2019_01.code
  • Sort Method: external merge Disk: 4966064kB
4. 16,756.849 71,608.838 ↓ 1.0 195,157,221 1

Append (cost=0.00..5,703,526.21 rows=195,014,795 width=16) (actual time=0.011..71,608.838 rows=195,157,221 loops=1)

5. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on refinitiv_2019_01 (cost=0.00..17.50 rows=200 width=44) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (date <= '2019-08-01'::date)
6. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on refinitiv_2019_02 (cost=0.00..17.50 rows=200 width=44) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (date <= '2019-08-01'::date)
7. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on refinitiv_2019_03 (cost=0.00..17.50 rows=200 width=44) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (date <= '2019-08-01'::date)
8. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on refinitiv_2019_04 (cost=0.00..17.50 rows=200 width=44) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (date <= '2019-08-01'::date)
9. 12,523.564 12,523.564 ↑ 1.0 43,279,597 1

Seq Scan on refinitiv_2019_05 (cost=0.00..898,797.05 rows=43,280,324 width=16) (actual time=0.007..12,523.564 rows=43,279,597 loops=1)

  • Filter: (date <= '2019-08-01'::date)
10. 19,469.478 19,469.478 ↓ 1.0 69,629,756 1

Seq Scan on refinitiv_2019_06 (cost=0.00..1,446,237.00 rows=69,628,810 width=16) (actual time=0.008..19,469.478 rows=69,629,756 loops=1)

  • Filter: (date <= '2019-08-01'::date)
11. 22,041.717 22,041.717 ↓ 1.0 77,741,511 1

Seq Scan on refinitiv_2019_07 (cost=0.00..1,616,544.80 rows=77,739,824 width=16) (actual time=0.304..22,041.717 rows=77,741,511 loops=1)

  • Filter: (date <= '2019-08-01'::date)
12. 815.714 817.215 ↓ 1.0 4,506,355 1

Bitmap Heap Scan on refinitiv_2019_08 (cost=1,121.91..766,802.36 rows=4,365,035 width=16) (actual time=1.519..817.215 rows=4,506,355 loops=1)

  • Recheck Cond: (date <= '2019-08-01'::date)
  • Rows Removed by Index Recheck: 2002
  • Heap Blocks: lossy=37376
13. 1.501 1.501 ↑ 11.7 373,760 1

Bitmap Index Scan on refinitiv_2019_08_date_idx (cost=0.00..30.66 rows=4,368,116 width=0) (actual time=1.501..1.501 rows=373,760 loops=1)

  • Index Cond: (date <= '2019-08-01'::date)
14. 0.011 0.011 ↑ 1.0 2 1

Seq Scan on refinitiv_default (cost=0.00..1.02 rows=2 width=16) (actual time=0.010..0.011 rows=2 loops=1)

  • Filter: (date <= '2019-08-01'::date)
Planning time : 0.303 ms
Execution time : 246,235.866 ms