explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Rnol : good

Settings
# exclusive inclusive rows x rows loops node
1. 0.063 38.026 ↓ 51.0 102 1

Unique (cost=516.52..516.64 rows=2 width=612) (actual time=37.958..38.026 rows=102 loops=1)

2. 6.368 37.963 ↓ 51.0 102 1

Sort (cost=516.52..516.53 rows=2 width=612) (actual time=37.956..37.963 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_.name, i (...)
  • Sort Method: quicksort Memory: 128kB
3. 0.000 31.595 ↓ 51.0 102 1

Nested Loop (cost=73.23..516.51 rows=2 width=612) (actual time=29.552..31.595 rows=102 loops=1)

4. 0.095 31.172 ↓ 53.0 106 1

Nested Loop (cost=72.80..510.97 rows=2 width=443) (actual time=29.540..31.172 rows=106 loops=1)

5. 0.156 4.861 ↓ 113.0 113 1

Nested Loop Left Join (cost=72.37..491.32 rows=1 width=387) (actual time=0.793..4.861 rows=113 loops=1)

6. 1.836 4.366 ↓ 113.0 113 1

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

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

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

8. 0.095 0.612 ↓ 203.0 203 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 69kB
9. 0.095 0.517 ↓ 203.0 203 1

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

10. 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.033..0.036 rows=2 loops=1)

  • Recheck Cond: (((name)::text = 'OPAP JOKER'::text) OR ((name)::text = 'OPAP JOKER JACKPOT'::text))
  • Heap Blocks: exact=2
11. 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)

12. 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)
13. 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)
14. 0.348 0.386 ↓ 17.0 102 2

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

  • Recheck Cond: (product_id = product11_.id)
  • Heap Blocks: exact=194
15. 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)
16. 0.339 0.339 ↑ 1.0 1 113

Index Scan using pk_creative_type on creative_type creativety10_ (cost=0.14..0.15 rows=1 width=31) (actual time=0.002..0.003 rows=1 loops=113)

  • Index Cond: (creative9_.creative_type_id = id)
17. 26.216 26.216 ↑ 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.229..0.232 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
18. 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