explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2oDd : bad

Settings
# exclusive inclusive rows x rows loops node
1. 0.012 39.458 ↓ 51.0 102 1

Limit (cost=517.69..517.81 rows=2 width=612) (actual time=39.373..39.458 rows=102 loops=1)

2. 0.069 39.446 ↓ 51.0 102 1

Unique (cost=517.69..517.81 rows=2 width=612) (actual time=39.371..39.446 rows=102 loops=1)

3. 6.399 39.377 ↓ 51.0 102 1

Sort (cost=517.69..517.70 rows=2 width=612) (actual time=39.369..39.377 rows=102 loops=1)

  • Sort Key: creative9_.id, creative9_.name, creative9_.slogan, creative9_.creative_start, creative9_.creative_end, creative9_.offer_end, creative9_.external_resource_server_hash, creativety10_.id, creativety10_.name, product11_.id, product11_.n (...)
  • Sort Method: quicksort Memory: 128kB
4. 0.018 32.978 ↓ 51.0 102 1

Nested Loop (cost=73.09..517.68 rows=2 width=612) (actual time=30.742..32.978 rows=102 loops=1)

5. 0.213 32.536 ↓ 53.0 106 1

Nested Loop (cost=72.66..512.14 rows=2 width=443) (actual time=30.731..32.536 rows=106 loops=1)

6. 0.754 5.655 ↓ 113.0 113 1

Nested Loop Left Join (cost=72.23..492.49 rows=1 width=387) (actual time=0.804..5.655 rows=113 loops=1)

  • Join Filter: (creative9_.creative_type_id = creativety10_.id)
  • Rows Removed by Join Filter: 1582
7. 1.913 4.449 ↓ 113.0 113 1

Hash Join (cost=72.23..491.16 rows=1 width=364) (actual time=0.792..4.449 rows=113 loops=1)

  • Hash Cond: (streamcrea8_.creative_id = creative9_.id)
8. 1.926 1.926 ↓ 1.0 16,457 1

Seq Scan on stream_creative streamcrea8_ (cost=0.00..357.30 rows=16,430 width=20) (actual time=0.010..1.926 rows=16,457 loops=1)

9. 0.103 0.610 ↓ 203.0 203 1

Hash (cost=72.22..72.22 rows=1 width=352) (actual time=0.610..0.610 rows=203 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 69kB
10. 0.095 0.507 ↓ 203.0 203 1

Nested Loop (cost=13.19..72.22 rows=1 width=352) (actual time=0.086..0.507 rows=203 loops=1)

11. 0.009 0.036 ↑ 1.0 2 1

Bitmap Heap Scan on product product11_ (cost=8.85..16.63 rows=2 width=32) (actual time=0.034..0.036 rows=2 loops=1)

  • Recheck Cond: (((name)::text = 'OPAP JOKER'::text) OR ((name)::text = 'OPAP JOKER JACKPOT'::text))
  • Heap Blocks: exact=2
12. 0.000 0.027 ↓ 0.0 0 1

BitmapOr (cost=8.85..8.85 rows=2 width=0) (actual time=0.027..0.027 rows=0 loops=1)

13. 0.019 0.019 ↑ 1.0 1 1

Bitmap Index Scan on product_name_index (cost=0.00..4.43 rows=1 width=0) (actual time=0.019..0.019 rows=1 loops=1)

  • Index Cond: ((name)::text = 'OPAP JOKER'::text)
14. 0.008 0.008 ↑ 1.0 1 1

Bitmap Index Scan on product_name_index (cost=0.00..4.43 rows=1 width=0) (actual time=0.008..0.008 rows=1 loops=1)

  • Index Cond: ((name)::text = 'OPAP JOKER JACKPOT'::text)
15. 0.338 0.376 ↓ 17.0 102 2

Bitmap Heap Scan on creative creative9_ (cost=4.34..27.74 rows=6 width=328) (actual time=0.034..0.188 rows=102 loops=2)

  • Recheck Cond: (product_id = product11_.id)
  • Heap Blocks: exact=194
16. 0.038 0.038 ↓ 17.0 102 2

Bitmap Index Scan on product_id_creative (cost=0.00..4.33 rows=6 width=0) (actual time=0.019..0.019 rows=102 loops=2)

  • Index Cond: (product_id = product11_.id)
17. 0.452 0.452 ↑ 1.0 15 113

Seq Scan on creative_type creativety10_ (cost=0.00..1.15 rows=15 width=31) (actual time=0.003..0.004 rows=15 loops=113)

18. 26.668 26.668 ↑ 14.0 1 113

Index Scan using creative_id_idx on stream_insertion streaminse0_ (cost=0.43..19.51 rows=14 width=64) (actual time=0.233..0.236 rows=1 loops=113)

  • Index Cond: (creative_id = streamcrea8_.id)
  • Filter: ((start_time > '2019-09-10 00:00:00'::timestamp without time zone) AND (end_time < '2019-09-11 00:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 261
19. 0.424 0.424 ↑ 1.0 1 106

Index Scan using pk_insertion on insertion insertion1_ (cost=0.43..2.76 rows=1 width=177) (actual time=0.003..0.004 rows=1 loops=106)

  • Index Cond: (id = streaminse0_.insertion_id)
  • Filter: (verified AND (cost IS NOT NULL))
  • Rows Removed by Filter: 0